-
Re: Count the number of rows where a column (multi select dropdown) has more than one value
Hi @latheobald89201, This should work: =COUNTIF({Attendee Role}, COUNTM(@cell) >= 2) Hope this helps, but if you have any problems then post what they are! 😊2 · -
Re: How to show 5 different sets of checkboxes in same column?
Hi @22Wordsmith, You can somewhat do this. If your subject data is in tick box columns, then you can use a formula to combine them and using wrap: The formula in the Subjects column being: =IF(Readin…1 · -
Re: How to create a formula column that calculates the difference between rows?
Hi @sweta22, You can use SUMIFS for this. Doing the formulas in the same sheet: =IFERROR(100 - ((SUMIFS([Last FY - Jun]:[Last FY - Jun], [Metric Name]:[Metric Name], [Metric Name 2]@row, [Plan - Actu…1 · -
Re: Return "Yes" if a date range includes a certain month
Hi @O.Nash, Bit of a throwback, but it'd probably be easier to do something like this (again, using Jan 2023 as an example): =IF(AND([Start Date]@row < DATE(2023, 2, 1) - 1, [End Date]@row >= D…1 · -
Re: Countifs formula Error
In your actual data, how many results are you expecting? You look to have added an extra status (Range 2, looking for "Production"), but this shouldn't stop thing working unless the criteri…1 ·